SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001111s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535760 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535760 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196276,328223,147500,375102,139565,270029,9756,598587,490372,12093,190355,602219,551284,63569,684634,181023,663350,380834,803427,461623,801747,189934,890344,913275,149812,187901,281082,1033307,561399,870577,586888,802181,134153,287909,1010241,740677,554883,1047848,551237,421869,7300,1016899,724712,634622,744898,225809,111233,774475,929379,628082,1007600,967103,922941,621135,68878,893108,457513,173451,538707,943473) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535760 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000433s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535760 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000429s ]