SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 473780 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 473780 [ RunTime:0.001911s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (258363,1027421,902964,37829,764692,29742,775436,52184,233843,587657,445229,850190,609621,145245,221750,569684,446753,844568,57657,364074,776291,972251,510458,892970,967656,33917,272164,815719,783559,553356,973203,894581,497425,973205,168384,867845,178128,592880,389192,329655,473972,225189,955650,378001,693677,266133,534152,302116,716969,589243,6437,493590,31577,93435,504593,147428,917183,104722,112550,76730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 473780 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 473780 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]