SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 334613 LIMIT 1 [ RunTime:0.000564s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 334613 [ RunTime:0.003134s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (180969,173263,278010,985414,346294,846072,27076,846030,41830,342386,98094,607880,472857,345974,216979,961548,160546,216751,325167,102117,624577,844441,50224,239670,415401,516902,1007090,795114,732470,705694,680054,51665,50242,922904,1025840,1025456,771223,180115,1014046,1009637,496991,761993,561315,313623,958823,456805,873491,74801,958955,695287,126265,881084,615874,95704,689680,966397,495179,792519,928094,476503) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 334613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 334613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000492s ]