SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 126818 LIMIT 1 [ RunTime:0.000284s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 126818 [ RunTime:0.002075s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601602,795586,64577,379250,151092,311963,971639,638839,627934,429382,83091,1024186,639541,1038703,186154,458384,165594,342592,1027260,79873,56234,769051,896,368399,698470,297340,548404,764968,353398,22099,95386,636349,822925,430459,25954,64134,961093,880897,1039872,1044488,623748,414613,552119,423704,718295,881121,387837,456094,222697,998396,1028736,841722,361801,208512,963216,1011224,202347,534340,492809,782143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 126818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 126818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]