SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311568 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311568 [ RunTime:0.003863s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558524,951227,923300,211676,421282,289187,985768,125659,966953,545851,41308,830552,284613,567872,44400,451147,934163,565540,716644,763381,109150,87392,1002702,172123,41329,693531,211751,264288,981001,853957,1022671,522730,25771,779031,320070,369975,698383,480683,866252,85879,61076,1032512,105373,267808,855016,728126,199942,647603,582451,169653,1004921,910944,670099,609610,719591,871281,116003,802336,299668,361853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]