SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001663 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001663 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (447568,886899,421179,16989,131953,708757,229593,617273,841753,187001,648940,89697,981201,21658,979075,328679,543623,236370,553211,372143,900566,27359,206980,13568,982049,678333,485889,989664,664984,710863,135707,11170,568530,100529,777313,618470,207201,534847,393691,419457,1008867,612930,885154,792102,844121,426395,768302,83052,930818,472144,357758,1012698,214455,477041,538633,751578,889713,43598,251133,809740) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002240s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]