SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41958 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41958 [ RunTime:0.002787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (326841,1022135,777726,388672,456731,890713,870258,244209,532780,941735,687935,657492,812809,560476,523296,715822,787123,749805,1047253,522128,690519,4858,774677,942324,967566,344793,816496,997666,168647,419565,882678,243586,1015780,351542,545609,638154,277729,657827,527357,127989,230762,745671,149730,595528,404240,544983,207602,448036,890299,433926,469811,627241,541341,771182,542300,445502,773650,603678,940836,282389) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000446s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000523s ]