SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10555 LIMIT 1 [ RunTime:0.000746s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10555 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (773165,11300,884330,810638,449473,719112,1037094,949893,390650,941948,504587,175659,499667,918240,483557,391003,207593,358166,439814,421198,323506,768467,985226,223556,846607,590583,913062,768219,355545,990438,323216,555420,150102,262908,997746,719082,756532,415902,442271,199714,586275,120413,350629,252234,594228,219436,224455,654053,127772,453737,808468,492053,504394,678782,965380,478594,138249,372144,782524,241377) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10555 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10555 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]