SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511748 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511748 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (371110,1035171,945703,262843,91011,391394,42137,109281,246594,730029,495531,850703,1000923,149481,776910,417074,564292,96370,171160,1034009,146996,747259,495583,819127,202810,793348,443422,854524,826556,568365,777867,507447,412303,515368,210897,105104,782583,582106,60906,280782,644490,839538,778397,340364,627562,566312,383464,456444,756582,1013933,892458,330082,821233,5991,753537,127213,20700,55531,560408,606804) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]