SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 825001 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 825001 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193438,15374,630750,380830,931757,902788,896372,657441,889747,847254,746513,325851,229052,417201,192519,708399,262104,253602,107646,1048109,640383,1025901,859446,791060,211381,286834,548865,571237,782753,102431,757568,647660,668412,39223,676257,515349,875636,100833,23413,890094,1008094,246000,244663,912623,124169,600709,342478,897458,230315,75435,994903,558199,354819,599298,187369,861757,258347,445311,858794,7408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 825001 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000517s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 825001 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]