SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 843088 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 843088 [ RunTime:0.001901s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013080,758020,708994,247482,500036,1007989,1034948,317919,1017386,801524,3488,875309,504426,759042,471509,397838,1021240,1018378,1635,75764,387851,933220,18843,663698,419200,632209,812064,1014133,734745,776409,333516,126498,677118,571871,967183,124027,436229,874829,939680,722831,408286,926547,398330,402984,319219,642730,203472,1019900,353292,347578,598556,435230,89628,32842,126231,131050,855822,795934,483874,950245) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 843088 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 843088 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000406s ]