SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548954 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548954 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191439,268810,629563,851748,25990,244038,662291,870634,898371,288050,345488,787852,973448,378444,679619,410454,244525,676313,570598,1031615,180500,891542,257136,396243,177081,9683,391931,572048,220019,117598,438680,405553,590198,832512,193198,86017,570,26440,965326,648773,260567,682029,814969,14476,605007,518755,451648,915735,1016127,58014,41367,250656,93709,245487,722656,419220,370135,949974,806303,571658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548954 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000567s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548954 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000654s ]