SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002586s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 987213 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 987213 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (415363,172620,654779,829663,1034115,147318,267686,124179,354313,940192,750809,331629,220002,191132,84951,308121,877866,427660,10642,355961,175934,992738,92257,1032715,493599,102,727380,85672,839069,642694,53567,393610,992172,592127,480664,366259,251695,706340,855423,574731,509398,615207,664645,279910,866593,859359,97960,396213,271343,593205,758826,1014751,711261,420256,123765,305591,554228,924048,889022,533230) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 987213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 987213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000764s ]