SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001576s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019810 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019810 [ RunTime:0.001616s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (91083,171467,268088,796339,267572,855629,676473,474008,634811,659652,239621,417402,676596,551177,172749,784793,637074,107375,1003644,63965,682124,973725,398413,867573,122509,854015,800605,524356,199490,509061,672536,795970,779709,74757,92888,792015,1016577,870901,474508,593631,403544,327642,798648,724459,579832,821702,796011,685432,1028678,702880,473698,489090,110204,904264,842941,973236,762085,609473,189226,357949) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]