SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 187498 LIMIT 1 [ RunTime:0.000384s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 187498 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (199345,528022,25919,45221,787021,426585,555696,891676,645967,1021008,211688,208438,993089,564376,706235,339735,234814,699026,10334,441548,644620,311237,276747,44539,538941,421237,880946,300987,324995,8176,805776,384911,122694,522589,803452,982496,102837,3189,46033,988223,141038,44212,186338,261254,866376,314062,1010900,878649,451172,887179,68359,391810,276155,400136,530483,1017926,993972,1014045,380836,676239) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 187498 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 187498 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]