SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004275s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 538714 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 538714 [ RunTime:0.004673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (868430,261512,3421,183772,35090,898016,37673,236072,834482,470461,64548,488630,956142,852907,107880,611439,359563,142891,125444,811348,62427,410195,658113,114155,57878,81166,404658,47181,330454,559753,250275,194735,725909,65447,159677,303272,638967,679338,460350,114415,997633,1030960,811357,130290,865516,112912,950656,501592,919152,493449,251035,80941,38993,776389,1027126,831336,254411,824493,587791,291513) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001668s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 538714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 538714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]