SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 300993 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 300993 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336000,1030431,149786,452014,960689,164089,539560,457873,242359,690165,679663,740851,891540,33127,31809,806229,852127,648285,1035096,602241,107160,59230,1031994,43678,685706,1028107,184293,270048,580934,1021639,70870,344903,194950,164499,248914,194105,109533,726815,598382,588325,319153,411989,867919,519952,1040699,148627,1003356,907121,2166,822175,829150,175710,416103,961871,121390,525030,295181,531901,1030357,967878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 300993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 300993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]