SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001215s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531329 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531329 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (486860,438835,605669,14010,729429,907559,199052,1047573,1019234,1038908,738157,359468,12005,353609,29837,398201,183309,571964,383199,102814,986957,698623,93162,818092,218990,679151,668594,672878,751659,990521,489273,984615,16827,657795,985344,995669,151513,734125,570651,817534,558789,426226,865309,562370,919229,787703,70890,912965,882579,973908,345323,373806,153105,313191,118171,443816,619642,239643,995389,718854) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531329 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531329 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]