SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001160s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032346 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032346 [ RunTime:0.001725s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (405401,341365,574200,342860,175828,320638,199266,1011552,702832,588116,862322,1018515,1027412,825924,22145,842714,620094,496435,49136,77944,414942,482537,105974,642331,278301,145584,267973,516799,629167,1001058,860119,408859,697641,576243,383832,976464,452677,70272,482167,1010102,346517,722135,1026079,642244,855571,1028568,538214,280499,1042104,443409,676346,1011955,594549,853863,56927,588516,220371,1007892,189193,872523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032346 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032346 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]