SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520416 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520416 [ RunTime:0.002895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (391358,606640,796627,187977,473177,33088,804386,213998,470333,28040,488913,269657,999761,197162,114087,63604,479352,160434,339312,790077,620828,157250,1008825,557290,172129,44902,530705,960353,134574,1035244,40311,889286,464073,98150,741883,567895,163640,940386,437443,256776,903146,958973,631075,360397,888575,180646,540527,458404,597448,674904,263914,1026446,756516,164487,309747,219797,748500,269968,482400,216924) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]