SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003771s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531203 LIMIT 1 [ RunTime:0.002360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531203 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (376138,974959,1013060,460090,374152,420669,719680,291332,1044785,462078,661871,35458,640401,838230,1042135,1009512,82333,771589,512987,429519,6801,818376,471623,9144,951422,1044340,337601,623400,504203,873504,513132,840170,8613,50937,593412,324669,16563,757685,961404,58688,492290,897954,390088,114078,707801,464930,480926,27317,560226,438994,492078,985729,931341,178769,143931,610157,1038804,612903,1007407,793013) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002562s ]