SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001441s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 471600 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 471600 [ RunTime:0.001584s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405366,553682,414068,632828,708175,218675,584159,123498,432681,462761,494987,49745,827333,393955,368214,195716,260278,720612,268844,293654,507845,472585,410659,646464,102840,517379,786554,991510,815626,449540,399661,147046,256516,140454,334731,936987,855347,1017765,292852,596045,932808,102856,272483,401159,913343,80137,266075,67927,283047,862167,503079,443824,227748,68483,124032,234736,823350,763649,578437,231306) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 471600 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000725s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 471600 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000482s ]