SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467816 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467816 [ RunTime:0.001913s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (915433,842762,772900,494518,476261,20777,655749,674081,242943,364104,824022,380628,461625,273855,849726,258392,437976,10420,19197,485488,154192,93422,194785,216189,312885,937649,571510,587340,110427,704864,324539,995113,847180,439396,584660,667036,353512,543988,180509,828716,688417,634384,937260,987682,725960,232859,150155,267103,899779,210574,339476,932706,726652,185236,21142,139024,831661,470023,1024255,390497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467816 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467816 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001475s ]