SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531071 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531071 [ RunTime:0.001626s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (735250,529435,806282,230156,691908,995864,467985,313766,472975,896380,453966,1010001,778942,187924,571103,805596,175707,686162,488359,532954,26853,233008,766520,287344,605455,1023239,927001,480541,15215,369812,849248,269943,551602,652833,938440,706087,253419,464152,601534,297797,595524,822527,686832,241592,706883,337021,321530,1037435,527819,193738,935184,966951,650965,305527,154093,917120,14602,775202,728396,374724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000947s ]