SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418418 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418418 [ RunTime:0.002181s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965246,278034,986828,392117,400537,140644,560445,564813,271404,814970,827351,952344,682384,888206,429510,163081,961926,440317,154757,757700,903758,976206,390132,460808,1031432,101085,995321,744499,477188,532735,973084,237270,510574,129001,1010898,89789,950940,42826,697466,839530,593085,445116,712353,668695,917206,887119,336345,29292,484808,874528,691787,221244,389217,840273,120363,594055,361421,506116,1028026,235350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418418 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000593s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418418 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]