SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019024 LIMIT 1 [ RunTime:0.002161s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019024 [ RunTime:0.003342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (254789,709289,561595,540344,247639,251910,779405,603808,906115,418122,235608,264607,786138,578070,528436,88644,815429,416891,603973,1033313,496116,139259,446984,598118,377078,168367,128376,1024414,557964,637717,365254,682422,670667,427667,418644,235736,330605,463558,727187,787218,743591,29502,999499,796210,366687,1015128,1011025,541917,539508,288615,1000169,428010,947943,316940,697379,157795,690624,203010,1034749,1018837) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019024 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019024 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000583s ]