SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407771 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407771 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569151,644098,800834,1018577,1044198,629818,341412,816830,30163,433217,762421,502876,620150,496823,488062,734743,692055,620367,475201,1012149,768884,176109,450748,503038,157105,432480,584595,187599,796719,112614,603336,363508,170235,263539,453810,1009387,930976,500752,432874,2404,935438,172152,679081,443995,434680,865490,584587,418489,127981,537492,698729,820488,482207,25762,90840,241330,370512,801889,109537,1026512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407771 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407771 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000564s ]