SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 475450 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 475450 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253308,669058,888460,707659,766179,328796,698549,431522,314719,835386,336962,909277,481077,377430,640263,195609,92514,798440,148938,278144,278137,965829,405084,887020,533503,563496,145164,681800,39593,837822,928611,17513,147671,442407,114691,88519,709901,559103,709772,63850,650406,773378,801332,1036581,604782,898202,991932,909309,850882,980819,535574,57557,349475,625611,175052,10303,1027330,767823,595305,254141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000936s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 475450 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 475450 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]