SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001727s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 500415 LIMIT 1 [ RunTime:0.000537s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 500415 [ RunTime:0.002116s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288247,229233,314902,732183,245330,65055,967782,780814,822987,942847,328890,641851,959288,872527,581123,848979,386933,521466,953907,430212,830838,545825,239051,11387,106556,382957,616909,8074,808869,318528,67844,569195,76950,24195,709849,637906,859075,1021462,220280,968473,652341,38085,872483,21943,572504,404564,607124,84107,159669,142678,608457,465585,970296,359397,672381,659118,282774,235864,218698,702812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 500415 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 500415 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]