SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002368s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535093 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535093 [ RunTime:0.002464s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010376,561516,818759,833690,304188,393790,891340,875016,567971,573664,669468,504656,997512,662876,335407,539927,412947,166971,365407,1002179,84796,359650,1024821,253297,546699,579427,406357,255925,202975,210569,507710,881325,458186,1037051,1003878,248520,1012211,726496,131634,210432,814646,391683,851177,834648,874472,1007066,481719,592754,826409,12422,983179,435274,872273,329126,796192,915770,744168,536157,990324,706324) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]