SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001243s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292346 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292346 [ RunTime:0.002467s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (977213,305619,475752,575875,172630,296072,135818,35194,640823,120672,470988,487982,901727,948148,499162,493868,733823,388765,364062,459097,543868,543346,678243,79124,972510,168602,555842,402647,330530,1026768,571632,701876,504902,885424,959390,669271,115887,895405,1008168,183392,788461,10441,145302,265015,950575,276616,585718,556404,475122,795326,349386,761925,186941,759212,654312,506364,793512,606288,368782,358816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]