SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040903 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040903 [ RunTime:0.001866s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (448519,774740,855510,513768,584304,749444,75951,651587,870874,363051,460691,278515,452743,185891,116927,223796,965755,911018,961730,61108,601769,1048025,554403,299075,433479,625499,164593,325238,763479,720047,419138,978868,844499,859185,569611,852668,648615,993228,772475,76869,468805,379759,425415,699914,810496,457206,683441,1037125,279223,939929,517619,549372,177726,959910,22090,427219,868366,1044126,316393,174865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001262s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040903 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040903 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]