SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 816470 LIMIT 1 [ RunTime:0.000445s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 816470 [ RunTime:0.001674s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (201114,809981,586723,108846,588473,382036,761420,404725,66087,440488,435076,203895,637775,107792,199092,188898,236589,331561,983669,394765,406180,951498,782492,397316,298715,206964,526531,338743,124787,728708,811180,397643,780059,376990,636918,514431,977934,458811,162034,393487,56147,1007217,143603,178467,142664,165840,712628,19107,89047,117278,887138,229851,798942,983145,679925,982726,888986,1028232,449370,715861) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 816470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000328s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 816470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]