SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505405 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505405 [ RunTime:0.004148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835288,380843,532504,379777,193673,752984,60385,422760,439311,1028122,109149,1525,316590,1035152,751963,167647,759680,634608,294820,697148,325992,231458,382963,985243,746479,53076,240963,124535,495868,897221,1023257,176729,1002115,919202,1020060,1010936,749662,827254,836824,299186,357784,480497,127882,1030612,154255,341233,829811,815823,495222,607893,689217,244790,562325,175773,932137,281182,956964,626468,983215,259850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505405 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505405 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]