SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10420 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10420 [ RunTime:0.001706s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (837848,108218,730385,460321,203189,403604,183774,127625,875671,744363,940188,589764,754841,30687,325550,944543,305890,630804,553795,142361,588691,893867,199416,1009301,878782,626802,759367,453045,177439,281743,311816,694177,331262,774433,478366,926520,1041604,296487,117437,762207,321673,298703,993973,671812,738337,317944,1034792,986102,129931,512792,582819,784002,109606,277983,919908,564506,520984,700931,999772,802013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001005s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10420 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10420 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]