SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580034 LIMIT 1 [ RunTime:0.000267s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580034 [ RunTime:0.001573s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150037,583300,328521,536689,777932,599926,985882,282884,730689,270365,401744,725332,103828,1031060,487228,181092,923305,406097,1033117,474535,274732,563854,357256,24810,684326,167275,954351,28316,389923,648438,812098,948252,366444,471035,336720,1015838,838439,668865,914701,984026,233878,39688,1047676,793424,889592,665817,308637,84163,499192,224093,34527,749558,658018,723380,625396,696661,389393,839613,989409,954136) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]