SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 812200 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 812200 [ RunTime:0.001855s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284390,1023641,543463,436432,580081,813686,1044762,778168,1026958,291879,952938,583762,558040,412990,871299,800700,212556,792950,725246,120041,1010746,920034,404739,875766,349689,331990,330318,986476,453771,79181,196687,632557,832101,542695,545966,392450,703948,9494,1010116,597336,552208,674419,196304,1024251,200266,50962,326901,910552,691807,427575,42417,318349,1002693,97653,719532,105302,197556,185581,540366,467031) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 812200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 812200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]