SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685004 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685004 [ RunTime:0.001571s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878013,149808,516187,695871,735740,921907,313640,194161,260561,588574,305960,466432,164100,857827,956802,912243,544410,735443,502883,395707,910217,929461,842669,65192,994723,253479,815437,954605,441242,926182,652147,983129,827121,1025505,561831,647341,645996,984737,983504,142207,701290,782238,957747,267496,72128,1024158,348380,957045,43482,800463,345137,251100,1002639,528049,125655,357541,861386,337555,204898,8475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004168s ]