SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001373s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445026 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445026 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (643488,1012279,712164,225708,507545,636363,680635,920608,172615,64916,853276,945640,414731,498426,627967,897247,272640,817674,690613,777801,870974,677333,820044,482848,662284,185172,684065,454987,651374,412667,140184,995408,608067,853369,931762,124366,321458,129958,127130,408607,383473,986925,369267,176788,564646,503931,992692,513748,410177,67748,545014,622629,85211,203887,72335,577937,248980,700269,856331,429137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]