SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406941 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406941 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25691,552089,220212,244036,270146,915484,900266,331466,447298,588758,397710,899470,567060,422174,450794,761088,559188,399932,112004,389163,548282,462366,686868,444688,872931,748433,869525,551291,761262,157204,263750,674278,297071,568700,843802,1022519,141013,689477,155156,569845,532618,869280,497494,904492,602394,69585,436336,35485,453888,244583,838096,638173,522002,256552,743984,391466,891139,971971,805836,284648) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000746s ]