SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1034313 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1034313 [ RunTime:0.002307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (764910,694602,956641,1019025,752731,583101,185157,915357,685571,800231,216370,432253,929266,771566,493821,797030,195779,436513,478853,31003,829058,280756,755521,213885,615908,82355,556946,479265,960864,163242,567687,666488,237618,127395,381774,314091,237678,655052,1037530,910392,710346,467963,38551,511046,23366,862602,267540,83679,129661,120417,121578,931357,275364,279477,371828,467134,726695,11145,470286,91944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1034313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000455s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1034313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]