SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412539 LIMIT 1 [ RunTime:0.001021s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412539 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (939018,281495,711358,446228,767092,734285,133239,724176,650508,713786,823870,359889,775876,581638,138083,184663,478163,923977,968454,596632,1023280,66580,655728,199773,840738,640460,222890,66269,802248,411975,400392,557891,341596,812013,549665,876608,226767,500509,217579,437299,532504,139370,597360,244536,230036,362016,1048290,534305,434249,655222,107465,227815,127162,810739,640225,502513,954848,136609,1032644,670819) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412539 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412539 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]