SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002964s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 428809 LIMIT 1 [ RunTime:0.001464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 428809 [ RunTime:0.002417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26113,333326,111793,173222,1048833,492722,622092,225101,973337,726907,29002,333261,936318,915357,966112,886281,746415,829962,585253,437832,751632,676690,772946,1036233,165544,55735,685724,764345,450961,291026,832397,489381,801248,678827,488967,458491,363306,496798,909301,59143,497752,999466,996831,216192,814926,556836,643447,921963,1000006,161249,616248,770400,836367,528873,143596,823750,910334,588654,353536,392672) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002147s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 428809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000553s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 428809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000666s ]