SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 106455 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 106455 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890418,571667,407840,183407,327939,726631,355352,88142,174987,725792,624440,357010,336706,892641,128254,50777,622722,137709,1010946,960834,829346,673252,480309,184589,391652,593422,1038031,368274,296399,205599,550357,71766,102971,783762,865359,537794,1000835,398745,335891,758020,867647,602734,475869,172036,1011548,355467,504511,736142,315153,706872,398751,842205,639660,976957,686165,902645,246910,575267,594589,515356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 106455 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 106455 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]