SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001408s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421560 LIMIT 1 [ RunTime:0.000532s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421560 [ RunTime:0.001779s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (997917,924786,861736,789104,383728,731156,678873,93452,35007,670265,454602,1008180,551820,440252,789831,940943,859636,813362,364095,244012,399008,512517,757964,331213,80367,259232,171498,661415,613020,941149,289503,501556,572848,31548,320150,29999,267727,704026,505547,265328,930325,850372,1048694,615162,170556,235554,196731,221587,724848,589162,625096,435436,424128,924130,187412,817985,382594,702127,740241,319352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421560 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421560 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]