SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413221 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413221 [ RunTime:0.002892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (680964,672614,341753,976097,178176,63656,367635,22389,594783,275185,318027,918363,466110,345290,235887,883474,217669,866206,700573,306874,968082,330431,247588,647898,84805,328329,110619,152775,775616,251285,283593,891082,1043775,127204,903573,964103,72866,622614,285123,486808,1040827,370166,841380,156756,666373,678164,823404,50640,634434,208853,405166,559079,283588,1020359,905996,662729,805658,257043,422097,243630) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413221 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413221 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]