SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 450611 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 450611 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015046,255502,711955,735253,926434,107051,207417,871319,64571,720738,879331,239799,1040764,895184,918209,611578,970232,10608,319768,127322,108792,620447,855981,353892,111315,993437,501522,606436,1014430,341820,567098,413117,378823,307393,51810,635158,824169,587537,997460,406231,206971,250375,960718,1019997,285655,208597,600378,1028652,846208,257072,239486,531443,71191,585832,587429,511632,997142,995920,1007461,815952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 450611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 450611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]