SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 356412 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 356412 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (651453,697232,122431,416102,237639,430134,64761,25129,863026,6793,503552,580019,892713,99447,129856,720603,776344,54863,952099,26035,101697,94915,158486,385283,945741,2208,1018598,454423,768846,312637,250797,576585,547868,625794,917232,183507,840178,174246,699593,554871,503007,531755,750552,109741,671171,818666,324111,608130,158460,87902,901593,606219,888010,83195,211745,183813,146663,705988,401947,590826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 356412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 356412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]