SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290923 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290923 [ RunTime:0.001548s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (262431,570211,555625,17346,544288,529846,504468,750293,510485,490835,709152,345589,923792,253275,207651,868249,335456,80541,155398,169301,866662,377896,109324,753355,680351,508759,688930,656393,971450,172827,659270,61754,437464,708787,562782,86988,736118,403623,405996,680343,76627,520089,787529,543281,428103,933409,485948,522310,183324,994449,574693,214434,458874,282999,527842,352970,804876,463585,965780,380354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290923 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290923 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000569s ]