SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200680 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200680 [ RunTime:0.004447s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (872998,688479,687194,580615,698833,627566,352461,603042,920522,95901,838710,484419,32736,179105,615300,552325,384348,609532,695810,409158,684319,441379,744691,1019107,459981,1018136,655042,916922,551320,49459,38410,12041,632685,90674,220380,857521,480589,375897,72791,467626,256690,600525,951702,511478,668603,834826,970387,676481,511448,492290,676085,801356,324293,868888,890785,77950,24560,707483,851376,654291) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]