SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 689083 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 689083 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (177804,370958,59827,260491,279965,894687,188176,1007069,685123,726511,595819,406200,514573,905031,667760,879450,738564,69460,564688,1014987,131004,631969,659694,63859,853253,848774,525595,874026,842640,241176,922129,834124,766571,773422,154986,21899,722378,670205,839294,685352,431759,325641,1045292,878477,689540,129337,28221,743135,483415,404344,784519,503979,608089,203335,356645,160240,112823,860220,705190,705475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 689083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 689083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000513s ]