SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002087s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 319973 LIMIT 1 [ RunTime:0.003439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 319973 [ RunTime:0.001915s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1004545,540933,151191,984497,493886,674048,522521,722628,725599,261088,209749,287649,836077,711031,680328,525224,846063,373992,127313,662279,38068,641563,888222,204842,549969,1023451,598711,256400,797276,499376,28302,520915,1026160,584744,622836,594931,969591,690123,230149,434861,135638,707507,837178,317286,39186,308160,664941,480006,768392,439130,490493,135787,883121,602619,819025,711695,195715,990652,642754,188774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 319973 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 319973 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]