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` = 611904 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 611904 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783317,254834,909954,915298,983407,514381,434418,89117,1041748,455300,500576,730003,294079,458583,11538,971324,874137,675196,831788,540564,956747,346809,312398,577770,509782,873654,104359,927835,924535,48727,1645,354896,915099,1006728,1015894,311719,1026617,729093,360466,626420,656805,277943,780284,1041817,835298,575605,680734,497047,716773,937579,987586,872410,554593,822015,796311,176030,727435,546696,432516,527752) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 611904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 611904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001015s ]