SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6721 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6721 [ RunTime:0.004122s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405366,675359,542441,1021456,820586,208531,372887,357018,926889,486330,59411,408775,389705,614289,444648,1020503,824681,612434,581845,232540,627692,391945,985243,843879,583688,580036,939785,592514,558330,939618,283462,74009,197907,776621,983368,680968,518165,986319,227605,837411,836593,904372,144710,788834,342750,696988,988285,168021,173166,655330,617207,498693,444299,368452,894585,641339,1009295,637660,109946,977451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001745s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6721 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6721 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]