SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001293s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 472851 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 472851 [ RunTime:0.002448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (896027,99522,958146,345122,776227,842098,1021265,421493,833673,99777,27189,439123,319576,323599,771173,996496,357578,552611,456146,7871,801925,241231,443938,541617,790700,408849,194913,513435,109496,1028831,134126,639145,49950,354593,472760,944488,933589,930454,838815,175927,373746,1026803,87155,161008,533254,728424,768086,644142,295892,383129,956884,38874,768188,14945,673921,650258,27860,317512,659318,572041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002466s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 472851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 472851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001216s ]