SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 301451 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 301451 [ RunTime:0.002449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (283379,272567,165109,655708,616816,50753,956812,902624,814794,170313,176117,596352,272008,381910,899319,780508,209740,205497,818761,374253,679580,823583,491700,962602,897940,899357,954116,644257,10741,75552,879630,1007550,820059,781493,270092,340916,884970,855581,565330,382002,81691,948280,339780,977170,857063,213308,778639,378402,987702,359843,738161,417043,546164,163540,70263,265991,68807,645342,592790,624997) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 301451 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 301451 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000512s ]