SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43201 LIMIT 1 [ RunTime:0.001716s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43201 [ RunTime:0.002183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603082,217056,646357,652654,33145,84993,483845,692249,503206,830736,793735,105700,831933,841070,310402,245036,551595,508912,815414,649424,290899,760812,127301,662400,806665,259975,182078,699404,549977,745499,881842,891618,476563,129950,274512,307883,904423,464058,1028078,822446,580700,290352,442004,294501,480062,437734,276374,201639,1017281,834498,379729,595054,38189,311975,980728,845305,577298,55807,621851,450428) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026750s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001928s ]