SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804806 LIMIT 1 [ RunTime:0.000281s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804806 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (141840,325815,901034,202658,354812,844361,203562,654572,583569,432065,824438,282587,615051,119382,87347,328576,769993,326205,303995,368048,133643,902473,462050,474817,84061,888012,139185,880442,902899,862034,764890,464514,290998,263408,555548,797259,983906,193731,196927,64967,357677,919456,857819,152436,125085,133549,309966,176996,437111,566351,805861,187355,686323,623718,770879,636274,653524,521134,262110,360125) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804806 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804806 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]