SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001563s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401571 LIMIT 1 [ RunTime:0.001140s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401571 [ RunTime:0.003240s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (347642,362882,836755,669539,566023,348643,412179,649029,63667,283366,972227,241546,682100,43962,961877,443436,859041,458170,15822,816810,780098,338102,344615,43150,936908,293330,199419,269466,736052,515123,378450,756854,277678,460896,302638,295765,669035,300289,601283,951173,546002,777872,930481,392591,784006,161034,1011828,595823,292480,400032,60077,212387,352371,443646,729761,218402,279895,209239,1015576,909942) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005325s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000525s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004257s ]