SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001273s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488348 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488348 [ RunTime:0.001971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400044,912412,861201,465282,346555,1027529,829079,725832,927323,883387,400941,855210,412669,182118,969937,339715,215101,750653,322411,111370,959930,887441,169411,844571,947569,85677,37597,1031015,631499,83009,560410,1036152,62963,831686,309912,470481,82605,736703,241458,567820,302631,853150,308966,28925,103558,229125,740511,358931,655263,1047041,391561,617387,964123,425551,995288,108920,205487,199392,974701,969860) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488348 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488348 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002292s ]