SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684309 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684309 [ RunTime:0.001952s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (136683,57586,746727,215343,877258,307224,24418,926382,314750,806891,583844,559320,1020105,454160,991821,492416,263368,874892,863484,261520,1010479,421801,429203,536073,326285,998601,944786,196529,571402,27429,359075,179438,119067,846793,182979,57476,35946,968708,267042,195965,601010,522783,1007786,868038,346674,282843,11818,251279,568777,324711,920519,825183,973303,1042386,611633,184559,547398,521827,12192,739585) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]