SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004868 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004868 [ RunTime:0.002659s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (99575,684360,77258,256104,422133,961420,1044856,753776,57227,1041339,131314,291757,871880,902569,777767,347248,523501,110283,303366,278557,619319,1036188,264093,342217,825549,794499,145360,694219,879264,874235,731405,922371,162671,500300,349631,657108,245240,751182,414891,918832,390816,769307,466509,718434,112860,717739,114459,153131,165929,712288,943500,840990,1042515,301309,553767,691236,289168,25925,216187,438117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001257s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004868 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004868 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000938s ]