SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 407728 LIMIT 1 [ RunTime:0.002684s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 407728 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (72880,374572,288394,911419,395067,559195,179529,316366,1027953,487573,149944,203151,547215,956184,480737,163530,1034750,735379,450539,40970,761237,432854,572977,450787,984362,131210,761934,991797,853476,798447,744185,922787,446065,196360,220891,907951,1009937,109722,1017836,428139,990927,53962,585772,293668,354306,596849,1032156,975983,156485,266011,36078,65315,1023733,885760,635521,17326,796124,928726,809814,961957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002764s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 407728 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 407728 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]